/*Note: In order for MySQL to bulk load a table, the data must be in this folder:
C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/

Note: There are some intentional errors in this data.  And some omissions. */


load data infile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/prof21.txt' 
into table prof
fields terminated by '\t'
lines terminated by '\r\n';

load data infile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/student21.txt' 
into table student
fields terminated by '\t'
lines terminated by '\r\n';

load data infile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/course21.txt' 
into table course
fields terminated by '\t'
lines terminated by '\r\n';

load data infile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/section21.txt' 
into table section
fields terminated by '\t'
lines terminated by '\r\n';

load data infile 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/report21.txt' 
into table report
fields terminated by '\t'
lines terminated by '\r\n';